How to find the link between transaction number and receipt number in AR

Hello Everyone, Am using Oracle R12, I want to get transaction details for the corresponding receipt number in AR. How can I get this. Can anyone help me regarding this issue. Thank you. Regards, Gurujothi

check the below

check the below tables AR_CASH_RECEIPTS_ALL AR_RECEIVABLE_APPLICATIONS_ALL ra_customer_trx_all

Thank You for your reply. I

Thank You for your reply. I need AP invoice number and check id along with the AR transaction details according to the Receipt Number. I tried but not getting any output. Thank you. Regards Gurujothi

How the AP & AR invoices are

How the AP & AR invoices are related - By 1> Intercompany AP AR relationship or 2> AR refund done through AP

It is 2> AR refund done

It is 2> AR refund done through AP